AnsweredAssumed Answered

Importing records with $ delimiters

Question asked by CharlesBlack on Jan 28, 2012
Latest reply on Jan 29, 2012 by CharlesBlack

Title

Importing records with $ delimiters

Post

HI All,

This should be ridiculously easy, but I am stumped.  The data I am trying to import is from the FDA adverse event reporting system if you want to look at it.

But here is the problem:

The file to import is tab delimited, but each record contains multiple fields delimited by $:  it is set up like this (i've simplified it)

UI$Codenumber$outcome$ <TAB>

24$110011$DE$ <TAB>

25$110011$HO$ <TAB>

 

In other words patient 24 took drug 110011 and death resulted

Patient 25 took drug 110011 and was hospitalized.

etc.

 

How do I get FM to read each field into a single record when I import it.  FM does not seem to like the $ delimiting the values and just gloms the whole string together as one field.  I have been looking around but to no avail.  Do I need to transform the data somehow to different delimiters?

 

Thanks for any help you can give me.

Best

Allen

Outcomes