Hi,
Having a bit of a problem with a csv file import
Structure is:
j225,28-Sep-06,139145,66515| 65126| 65070,1799459
j225,28-Aug-06,139115,73527| 69354| 66515| 65126| 65096| 69333,L1796208
j225,01-Sep-06,139122,66515| 65096,L1796669
List element 5 ( obtained by ListGetAt(CSV_RECORD,5,"," )> should contain
1799459, or L1796208.
However item 1799459 works okay, but L1796208 comes out with what I can only
describe as a carriage return\line feed after it (so too does L1796669)
to best illustrate it, the variable used in a query:
SELECT SB_PATIENT_MRN,
SB_DEBTOR_ID
FROM SB_PATIENT_REGISTER
WHERE SB_PATIENT_MRN =
'L1796208
' AND
SB_HL7_SOURCE =
'LMNC'
I have opened the file up and retyped the last values. I have opened the csv
file up in a text editor to check for hidden characters (at the end of each
line there is a CRLF ).
Can anyone offer any advice?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
