alltrim and file.create syntax

[John Cunradi]

I have an XBasic function that uses file.create to create a text file.
One line reads this: file_pointer.write_line("SYS_APPNAME = "+ chr(34)+tbl.sys_appname + chr(34))

and it yields this: SYS_APPNAME = "ABCDE "
where ABCDE is the data in the field.

I would like it to yield this: SYS_APPNAME = "ABCDE"
Note: the trailing blanks are removed.

I've tried the Alltrim() function but I just can't seem to get the syntax right.
I always get a message "Argument is incorrect data type"

What am I missing here ?

Thanks.

[Al Buchholz]

Re: alltrim and file.create syntax

please show what you have tried with alltrim()

[Raymond Lyons]

Re: alltrim and file.create syntax

What Al said. But, also have you tried alltrim(tbl.sys_appname) in the line in question?

Raymond Lyons

[Tim Kiebert]

Re: alltrim and file.create syntax

Another possibility is using the concatenation operator with trim ie -

file_pointer.write_line("SYS_APPNAME = "+ chr(34)+tbl.sys_appname - chr(34))

[John Cunradi]

Re: alltrim and file.create syntax

Here is a list of all the variations I tried and their errors reported:

file_pointer.write_line(alltrim("SYS_APPNAME = "+ chr(34)+tbl.sys_appname + chr(34)))
no error warning but didn't work either

alltrim(file_pointer.write_line("SYS_APPNAME = "+ chr(34)+tbl.sys_appname + chr(34)))
Argument is incorrect data type

file_pointer.write_line("SYS_APPNAME = "alltrim(+ chr(34)+tbl.sys_appname) + chr(34))
Argument is incorrect data type

file_pointer.write_line("SYS_APPNAME = "+ chr(34)alltrim(+tbl.sys_appname) + chr(34))
Argument is incorrect data type

file_pointer.write_line("SYS_APPNAME = "+ chr(34)(alltrim(+tbl.sys_appname)) + chr(34))
Argument is incorrect data type

Any ideas what I'm missing ?

[Allen Klimeck]

Re: alltrim and file.create syntax

file_pointer.write_line("SYS_APPNAME = "+ chr(34)+(alltrim(tbl.sys_appname)) + chr(34))

or use what Tim suggested

[Stan Mathews]

Re: alltrim and file.create syntax

Any ideas what I'm missing ?

John,

The only issue you began with was that there were one or more trailing spaces generated by

file_pointer.write_line("SYS_APPNAME = "+ chr(34)+tbl.sys_appname + chr(34))

yielding SYS_APPNAME = "ABCDE "

That would lead one to believe that the only part of your expression that needed alltrim was the part that supplied the ABCDE in "ABCDE ".

Applying alltrim() to only that portion would seem to be indicated, no?

Note that

file_pointer.write_line("SYS_APPNAME = "+ chr(34)+tbl.sys_appname + chr(34))

can be written

file_pointer.write_line("SYS_APPNAME = "+ quote(tbl.sys_appname))

[John Cunradi]

Re: alltrim and file.create syntax

Allen, that did the trick.

I tried Tim's suggestion with no luck.

Thanks.

[Raymond Lyons]

Re: alltrim and file.create syntax

Did you try what I suggested? (Basically Allen's suggestion.) For that matter Tim's suggestion should work too, so we would need to see exactly how you tried any of these suggestions.

Raymond Lyons

[John Cunradi]

Re: alltrim and file.create syntax

This line worked :
file_pointer.write_line("SYS_APPNAME = "+ chr(34)+(alltrim(tbl.sys_appname)) + chr(34))

Thanks again.

[Raymond Lyons]

Re: alltrim and file.create syntax

Good. But for future reference, Tim's suggestion

file_pointer.write_line("SYS_APPNAME = "+ chr(34)+tbl.sys_appname - chr(34))

should also work, and so should the following, incorporating Stan's point:

file_pointer.write_line("SYS_APPNAME = "+ quote(Rtrim(tbl.sys_appname))

Raymond Lyons

[Al Buchholz]

Re: alltrim and file.create syntax

John

I prefer to use the interactive window to help build code and test it piece by piece...

So I would build a variable that contains the command that I want to execute like this...

tbl.sys_appname="test "

cmd="SYS_APPNAME = "+ chr(34)+tbl.sys_appname + chr(34)

?cmd
= SYS_APPNAME = "test "

cmd="SYS_APPNAME = "+ chr(34)+alltrim(tbl.sys_appname) + chr(34)

?cmd
= SYS_APPNAME = "test"

file_pointer.write_line(cmd)