Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Put double quotes around the values.
Put double quotes around the values.
Or use a different delimiter like pipe (|)
LOAD * Inline [
blah blah
] (delimiter is |);
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 '|' );
Both seem like excellent options. Thanks for the quick response.
Have you tried placing quotes around your values?
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.