Author |
Message |
jazzright
Newbie
Joined: 01 Apr 2008
Location: Fiji
Online Status: Offline
Posts: 15
|
Topic: how to replace \r\n before exporting from crystal Posted: 08 Jul 2008 at 9:00pm |
I am using crystal report Xl with vs2005 and i want to export to text file. I can export but after 32 lines a box symbols shows. How can i remove that. How can i remove \r\n before exporting to text file. please advice me.
|
IP Logged |
|
BrianBischof
Admin Group
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
|
Posted: 08 Jul 2008 at 9:39pm |
You can't change anything on the report just for the export process. You could create a formula so that strips those characters out of your text, but I assume that you have many fields and this could be a lot of formulas that you need to build. Otherwise, I don't think its possible.
|
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
|
IP Logged |
|
jazzright
Newbie
Joined: 01 Apr 2008
Location: Fiji
Online Status: Offline
Posts: 15
|
Posted: 08 Jul 2008 at 9:42pm |
thats what i want to do . Can you please show me the code how to do this please......
Much appreciated.......
|
IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 09 Jul 2008 at 1:07am |
Hi,
You can use replace function , it will be
trim(replace({table.fieldname},'\r', ''))
same for \n
Cheers
Rahul
Edited by rahulwalawalkar - 09 Jul 2008 at 1:07am
|
IP Logged |
|
sashalewis1014
Newbie
Joined: 09 Jul 2008
Location: United States
Online Status: Offline
Posts: 5
|
Posted: 09 Jul 2008 at 12:47pm |
I am using the same replace process but need to have two evaluations and replacements
trim(replace({table.fieldname},'\r', ''))
trim(replace({table.fieldname},'\s', &))
How do I combine two of the trim(replace into one formula????
|
Sasha Lewis
Database Development Manager
PKD Foundation
sashal@Pkdcure.org
|
IP Logged |
|
jazzright
Newbie
Joined: 01 Apr 2008
Location: Fiji
Online Status: Offline
Posts: 15
|
Posted: 10 Jul 2008 at 3:08pm |
still iam getting the page break symbol....
|
IP Logged |
|
sashalewis1014
Newbie
Joined: 09 Jul 2008
Location: United States
Online Status: Offline
Posts: 5
|
Posted: 10 Jul 2008 at 7:04pm |
were you able to get rid of the /r but you still have the /n in the file? If so, I founda way to get around that. I do not it if it is the easiest but it worked.
I created the first formula "Address Line 1":
trim(replace({address1}, '/r/', ''))
I created a second formula "Adress Line 1 Trim"
Put the second formula in the report and worked perfectly.
|
Sasha Lewis
Database Development Manager
PKD Foundation
sashal@Pkdcure.org
|
IP Logged |
|
jazzright
Newbie
Joined: 01 Apr 2008
Location: Fiji
Online Status: Offline
Posts: 15
|
Posted: 10 Jul 2008 at 8:37pm |
hi, r you exporting it to the text file. I have tired but still not getting it....so i have to it in my code or is crystal report...
struggling with this issue ..................
Edited by jazzright - 10 Jul 2008 at 8:37pm
|
IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 14 Jul 2008 at 2:07am |
Hi,
Can you post some sample data ...
Cheers
Rahul
|
IP Logged |
|
|