mibuso.com

Hi,

I have a problem in the delimiter on m y text field...

for example the value in my field is "123,1235","3335","2351,23",1234567 include the double quotation mark..

what i want is the result is going to be like this

var[1] = "123,1235"

var[2] = "3335"

var[3] = "2351,23"

var[4] = 1234567



hope someone will help me..

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV/Navision Classic Client' forum]

And for import/export and how (dataport,xmlport,other)?

anyone can help me about this.....plsssssssssssss

Clearly you need to choose a different delimiter

but, that's the current delimiter of the customer..and they don't want to change it to any..

I'm a bit loss on what you're trying to do. Export ? Import ?

umm..Import, co'z I'm creating a report..

how come the 2nd value has quotation, but not the 4th ?

"3335"
1234567

Sorry, typo error... actually it have quotation..

Dataports won't work like that, sorry. If you use " as field start and end delimiter, and , as field separator, dataports always get confused when field values contain a , it sucks but that's reality. For some reason, even though you put the , between " and " dataports still interpret the , as a field separator and it will fail.

The only reliable ones that I've found are <TAB> as field separator and <None> as field start and end delimiters.

I REALLY dislike dataports by the way....

And even <TAB>'s are not 100% reliable. Sometimes a <TAB> creeps into the data to be imported. But at least it is not a problem of the import but the export must clean up its data to be exported.
But at least it is a lot better than "," or ";".

I've always used ; as delimiter and [ ] as start and end delimiters. Works like a charm almost every time. (The only time it shouldn't work is if the data contains [ or ] which has never happened in my cases.

I've found any character that I've attempted to use as a field separator as part of actual field values. Regardless of the field start and end delimiters, if the field separator is part of the value, it gets confused and fails. It makes no sense because you would expect the separator and delimiters to work together, but I've found that is simply not reliable.

Did I mention that I REALLY dislike dataports?

So this is an Import report & not a dataport, correct?
and you are being provided the data by someone else, correct?
do you want to retain the commas? If not delete them once in excel and resave the file as text.
But I would suggest "importing" not just opening in excel & then saving it as TAB seperated.

Or you could just write code to read and process the file as a text file.