mibuso.com

Microsoft Business Solutions online community
It is currently Sat May 25, 2013 7:05 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 19 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: Delimiter in Text Field
PostPosted: Wed Apr 04, 2012 7:55 am 
Offline

Joined: Wed Apr 04, 2012 7:53 am
Posts: 7
Country: Philippines (ph)
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..


Top
 Profile E-mail  
 
 Post subject: Re: Delimiter in Text Field
PostPosted: Wed Apr 04, 2012 9:19 am 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7504
Location: Milan
Country: Italy (it)
[Topic moved from 'NAV Tips & Tricks' forum to 'NAV/Navision Classic Client' forum]

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

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting


Top
 Profile  
 
 Post subject: Re: Delimiter in Text Field
PostPosted: Tue Apr 10, 2012 4:37 am 
Offline

Joined: Wed Apr 04, 2012 7:53 am
Posts: 7
Country: Philippines (ph)
anyone can help me about this.....plsssssssssssss [-o<


Top
 Profile E-mail  
 
 Post subject: Re: Delimiter in Text Field
PostPosted: Tue Apr 10, 2012 5:21 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jan 02, 2003 6:37 pm
Posts: 7931
Location: Howell, MI
Country: United States (us)
Clearly you need to choose a different delimiter

_________________
Daniel Rimmelzwaan
MVP - Dynamics NAV


Top
 Profile  
 
 Post subject: Re: Delimiter in Text Field
PostPosted: Tue Apr 10, 2012 8:51 am 
Offline

Joined: Wed Apr 04, 2012 7:53 am
Posts: 7
Country: Philippines (ph)
but, that's the current delimiter of the customer..and they don't want to change it to any..


Top
 Profile E-mail  
 
 Post subject: Re: Delimiter in Text Field
PostPosted: Tue Apr 10, 2012 9:04 am 
Offline

Joined: Mon Oct 24, 2011 2:58 am
Posts: 142
Location: Tokyo
Country: Japan (jp)
I'm a bit loss on what you're trying to do. Export ? Import ?

_________________
Microsoft Certified IT Professional for Microsoft Dynamics NAV

Just a happy frood who knows where his towel is


Top
 Profile E-mail  
 
 Post subject: Re: Delimiter in Text Field
PostPosted: Tue Apr 10, 2012 9:14 am 
Offline

Joined: Wed Apr 04, 2012 7:53 am
Posts: 7
Country: Philippines (ph)
umm..Import, co'z I'm creating a report..


Top
 Profile E-mail  
 
 Post subject: Re: Delimiter in Text Field
PostPosted: Tue Apr 10, 2012 9:35 am 
Offline

Joined: Mon Oct 24, 2011 2:58 am
Posts: 142
Location: Tokyo
Country: Japan (jp)
how come the 2nd value has quotation, but not the 4th ?

"3335"
1234567

_________________
Microsoft Certified IT Professional for Microsoft Dynamics NAV

Just a happy frood who knows where his towel is


Top
 Profile E-mail  
 
 Post subject: Re: Delimiter in Text Field
PostPosted: Tue Apr 10, 2012 10:46 am 
Offline

Joined: Wed Apr 04, 2012 7:53 am
Posts: 7
Country: Philippines (ph)
Sorry, typo error... actually it have quotation..


Top
 Profile E-mail  
 
 Post subject: Re: Delimiter in Text Field
PostPosted: Tue Apr 10, 2012 2:46 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jan 02, 2003 6:37 pm
Posts: 7931
Location: Howell, MI
Country: United States (us)
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....

_________________
Daniel Rimmelzwaan
MVP - Dynamics NAV


Top
 Profile  
 
 Post subject: Re: Delimiter in Text Field
PostPosted: Tue Apr 10, 2012 3:03 pm 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7504
Location: Milan
Country: Italy (it)
DenSter wrote:
The only reliable ones that I've found are <TAB> as field separator and <None> as field start and end delimiters.

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 ";".

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting


Top
 Profile  
 
 Post subject: Re: Delimiter in Text Field
PostPosted: Tue Apr 10, 2012 3:20 pm 
Offline

Joined: Thu Oct 30, 2008 10:38 am
Posts: 987
Location: Earth
Country: Netherlands (nl)
DenSter wrote:
The only reliable ones that I've found are <TAB> as field separator and <None> as field start and end delimiters.

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.

_________________
|Pressing F1 is so much faster than opening your browser|
|MCBMSS: 5.0 intro|MCTS:NAV09 839..841|JetReports© Certified Specialist|
|Dynamics Anywhere: Mobile Business Solutions|


Top
 Profile  
 
 Post subject: Re: Delimiter in Text Field
PostPosted: Tue Apr 10, 2012 3:28 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jan 02, 2003 6:37 pm
Posts: 7931
Location: Howell, MI
Country: United States (us)
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?

_________________
Daniel Rimmelzwaan
MVP - Dynamics NAV


Top
 Profile  
 
 Post subject: Re: Delimiter in Text Field
PostPosted: Tue Apr 10, 2012 4:11 pm 
Offline
MVP Microsoft Dynamics NAV
Site Supporter

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 6979
Location: L.I., New York
Country: United States (us)
aztiguen24 wrote:
umm..Import, co'z I'm creating a report..


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.


Attachments:
Delimeter.JPG
Delimeter.JPG [ 61.23 KiB | Viewed 707 times ]

_________________
Harry Ruiz
http://www.cosmeticsolutions.com
http://www.autismspeaks.org


Last edited by Savatage on Tue Apr 10, 2012 5:20 pm, edited 1 time in total.
Top
 Profile E-mail WWW  
 
 Post subject: Re: Delimiter in Text Field
PostPosted: Tue Apr 10, 2012 5:04 pm 
Offline

Joined: Fri Aug 06, 2004 9:30 pm
Posts: 899
Location: Richardson
Country: United States (us)
Or you could just write code to read and process the file as a text file.

_________________
David Machanick
http://mibuso.com/blogs/davidmachanick/


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 19 posts ]  Go to page 1, 2  Next

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Google [Bot] and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: