Copy and Paste the following formula using your data where necessary.
Description:
Replace underscores to spaces
{k3field}.replaceAll("-"," ")
Click to copy
Replace Parts of a String
Updated on
K3 7.0 User Guide
Getting Started 4
Routes 5
Data Stream 10
- How Do I View My Data In the Data Stream?
- How Do I View Source Data?
- How Do I View Target Data?
- How Do I Hide Columns I See in the Data Stream?
- How Do I Export Data to CSV or to Excel?
- How Do I Generate a Report From Data Streams
- How Do I Distinguish Between Source and Target Data in Filtering?
- How Do I Filter Data In Data Stream?
- How Do I See The Status Of Data in K3 Data Stream?
- How Do I Upload a File For a File Upload Route
Mapping 6
Rules 5
Formula Rules 18
- Convert Currency Symbols to Strings
- Trim a Field
- Absolute Value
- Nested IF Statement
- Add/Subtract Time to a Date
- Compare Dates
- Adjust a Date by Adding or Subtracting Months
- Replace Parts of a String
- DateTime Manipulation
- Round Decimal Values
- Days Between Two Dates
- Date to String with Formatting
- Cast to Integer
- Padding a String with Characters
- Parse a String / Extract a Substring
- Hashing Values
- 'Like' Regex Values for Use with When Statements
- Convert EU Currency Value Stored in String to Decimal
Reporting 1
My Account 1
Adaptors 15
- Amazon Redshift Source Adaptor
- Amazon Redshift Target Adaptor
- Snowflake Target Adaptor
- CSV Upload Adaptor
- JSON Upload Adaptor
- XML Upload Adaptor
- SQL Server Source Adaptor
- SQL Server Target Adaptor
- HTTP Source Adaptor
- CSV over FTP Adaptor
- Configuring the Scheduler
- Merge Route
- PostgreSQL Source Adaptor
- Oracle Source Adaptor
- Fixed Width