Mapping Load with Commas in Data

[Anonymous]

Greetings Forum,

Looking for a quick answer on this.  I created a mapping table with 4 values.   3 of my 4 values have a comma mid value.   My data load is going to take a long time and I have not had to deal with this before.  How do  I insure the whole value is considered in the applymap statement.   Do I put single quotes around the values, double quotes or parenthesis or something else?

See my PNG file for view of my script

I looked through the forum and did not find the answer

Thanks for any responses

[Gysbert_Wassenaar · Accepted solution]

Put double quotes around the values.

[sunny_talwar]

Or use a different delimiter like pipe (|)

LOAD * Inline [

blah blah

] (delimiter is |);

[petter]

You can use another delimiter instead of comma perhaps - like vertical bar ?

Hypoclycemia:

MAPPING LOAD * INLINE [

HIC3_DESC | Drugs

INSULINS | Yes

ANTIHYPERGLYCEMIC, INSULIN-RELEASE STIMULANT TYPE | YES

ANTIHYPERGLYCEMIC, INSULIN-REL STIM.& BIGUANIDE CMB  | YES

ANTIHYPERGLYCEMIC, THIAZOLIDINEDIONE AND SULFONYLUREA | YES

] (delimiter is '|' );

[Anonymous]

Both seem like excellent options.  Thanks for the quick response.

[Anonymous]

Have you tried placing quotes around your values?

[Anonymous]

Love that option.  We often have descriptive data where commas slip in, so we might be using vertical bars as delimiters as SOP in the future.

I solved my immediate problem using the double quotes and my data loads and works as expected.   Thanks again for all of the responses and I also plan to use alternate delimiters in the future too.

I started out only needing to solve my problem, but ended up gaining some extra wisdom in the process.