Format Text - Web scraping and data integration software - Djuggler Forum - Default Group - Community Support

Unanswered Active Topics

Forums Search

Forums > Default Group > Community Support

Format Text

Last Post 04 Mar 2010 06:03 PM by Tijn. 1 Replies.

Sort:

Check this box to subscribe to this topic.	Prev Next
Add Reply

Author

Messages

Peter Riech

03 Mar 2010 09:53 PM
I have extracted paragraphs from a web site, these paragraphs are about 5-10 sentences in length. I save to Excel but the formatting of the paragraphs is very poor once its imported into excel I use this formula in Excel, =TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32))) to clean it up...((from Microsoft site: Replaces each nonbreaking space character (Unicode value of 160) with a space character (ASCII value of 32) by using the SUBSTITUTE function, and then removes the leading and multiple embedded spaces from the string " BD 122" (BD 112)remove the white spaces which makes it format clean.)) Can I do this in Djuggler so i dont need to run an extras function in Excel? thanks

Tijn

04 Mar 2010 06:03 PM
You can use a replace text action to replace all to a normal space. Or you can use the Strip HTML action and of course there the trim right en left action. Hope this helps Tijn

Add Reply

Forums > Default Group > Community Support

Quick Reply

toggle

	Username:
	Subject:
	Body:
	Security Code:	Enter the code shown above:
Submit

Powered by Active Forums

	Forum participation and optional registration You don't need to be registered to partcipate in the Djuggler forums, however if you want to subscribe to email notifications you need to register. You can also subscribe to the forum RSS feed. Forum participation and optional registration You don't need to be registered to partcipate in the Djuggler forums, however if you want to subscribe to email notifications you need to register. You can also subscribe to the forum RSS feed.