Who's On?

	Membership:
	Latest: jmc
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5210

	People Online:
	Visitors: 374
	Members: 0
	Total: 374

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

data cleaning

2 Replies

0 Subscribed to this topic

52 Subscribed to this forum

Sort:

Author

Messages

TommyT

Veteran Member

Posts: 58

2/9/2011 12:43 PM

I have a data source that contains special characters (/ \ ) in several fields and I have to write it out without those characters - they should be replaced by spaces.

Is there an accepted way to do this in a flow?

David Williams

Veteran Member

Posts: 1127

New Poster

2/9/2011 1:19 PM

You can use the JavaScript .replace() function to take those special characters out of your variable.
Look it up at http://www.w3schools.com/...ef/jsref_replace.asp

John Henley

Posts: 3364

New Poster

Engaged Reader

Avid Reader

2/9/2011 1:22 PM

Use the Assign node with the javascript .replace() method.