EasyMorph Help

User Tools

Site Tools

You are here: start » transformations » sanitize
transformations:sanitize

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
transformations:sanitize [2021/04/11 01:08] – craigttransformations:sanitize [2021/07/19 02:18] (current) – [Examples] craigt
Line 27: Line 27:
 |Tabs|Select how tab characters embedded in the text will be handled.  Options: //Do nothing//, //Remove//, //Remove repeating//,\\ and //Replace with spaces//.| |Tabs|Select how tab characters embedded in the text will be handled.  Options: //Do nothing//, //Remove//, //Remove repeating//,\\ and //Replace with spaces//.|
 |Line breaks|Select how line breaks embedded in the text will be handled.  Options: //Do nothing//, //Remove//, //Remove repeating//,\\ and //Replace with spaces//.| |Line breaks|Select how line breaks embedded in the text will be handled.  Options: //Do nothing//, //Remove//, //Remove repeating//,\\ and //Replace with spaces//.|
-|Remove ASCII FE-FF|When checked, the "FF" (form feed) character will be removed.|+|Remove ASCII FE-FF|When checked, the characters with ASCII codes 0xFE (hexadecimal, 254 decimal) and 0xFF (hexadecimal, 255 decimal) will be removed.|
 |Trim leading spaces|When checked, whitespace occurring at the start of text will be removed.| |Trim leading spaces|When checked, whitespace occurring at the start of text will be removed.|
 |Trim trailing spaces|When checked, whitespace occurring at the end of text will be removed.| |Trim trailing spaces|When checked, whitespace occurring at the end of text will be removed.|
Line 41: Line 41:
 =====Examples===== =====Examples=====
  
-**Objective:** Clean out all unneeded text characters.\\+**Example:** Clean out all unneeded text characters.\\
 \\   \\  
 **Source data:** (raw text shown for clarity) **Source data:** (raw text shown for clarity)
Line 59: Line 59:
 >Row 4 requires //Remove repeating spaces// >Row 4 requires //Remove repeating spaces//
 >Sanitize all columns. >Sanitize all columns.
- 
  
 \\  \\ 
-**Output:**+**Result table:**
 ^Sample Text^ ^Sample Text^
 |2 Leading spaces| |2 Leading spaces|
Line 69: Line 68:
 |2 spaces here-> and 3 spaces here-> .| |2 spaces here-> and 3 spaces here-> .|
  
 +\\ 
 +====Community examples====
 +  * [[https://community.easymorph.com/t//2008/2|“Printed” Text File: Could EasyMorph import this?]] ([[https://community.easymorph.com/uploads/short-url/kIb1qqOJb9WK6D1N1jFZdnHzC46.morph|Project]]; Module: //Parse Group//; Group: //Tab 1//; Table: //Header (3)//; Action position: //5//)
 +  * [[https://community.easymorph.com/t//2160/1|How to pull data from web APIs with pagination]] ([[https://community.easymorph.com/uploads/short-url/dvCSpcEDXYZ8aB0B2gtnt7qulTF.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Query API with pagination//;\\ Action position: //5//)
 +
 +\\ 
transformations/sanitize.txt · Last modified: 2021/07/19 02:18 by craigt
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki