105
Hello All,
please help me out, for one web service I'm receiving tab-delimited text file in response, I'm copying manually the file data to excel for processing. can anyone tell me how to automate this process in nav
*This post is locked for comments
Hi Hannes Holst,
thanks for reply, I was able to import tab delimited flat file into a table in nav and also able to export it to excel sheet, is there any way to automate this i.e can we directly create and write data into excel from this tab delimited flat text file
thanks
Hi,
You are able to check characters based on the Codepage.
For instance, I use this often to identify a carriage-return character in a file.
I just stole the following code from another forum :-)
You must figure out number in the codepage your TAB has and replace it accordingly.
Share
Report
All responses (
Answers (
CHAR10 := 10;
CHAR13 := 13;
POS := STRPOS("Your Field", FORMAT(CHAR10));
IF POS <> 0 THEN ERROR('Pasting Canceled Carrage Return Exists');
POS := STRPOS("Your Field", FORMAT(CHAR13));
IF POS <> 0 THEN ERROR('Pasting Canceled Line Feed Exists');
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156