Watch videos with subtitles in your language, upload your videos, create your own subtitles! Click here to learn more on "how to Dotsub"


0 (0 Likes / 0 Dislikes)
  • Embed Video

  • Embed normal player Copy to Clipboard
  • Embed a smaller player Copy to Clipboard
  • Advanced Embedding Options
  • Embed Video With Transcription

  • Embed with transcription beside video Copy to Clipboard
  • Embed with transcription below video Copy to Clipboard
  • Embed transcript

  • Embed transcript in:
    Copy to Clipboard
  • Invite a user to Dotsub
One of the most common operations when you're working with queries like this is splitting columns up, particularly if you've connected to [inaudible] and you're getting some web data back, you might find the comma separated or split up by some other delimiter. And if you want to separate a column and split it up based on either the number of characters or by delimiter, there's a simple transformation for doing that. Over on the transform tab, you'll find the split column option. You can also find it by right clicking the top of a column and choose split column down here. And again, the options you get are by delimiter character or by number of characters. So I'm going to use the delimiter here, and because I want to split on the space to separate our product and the product code. And the abbus piece is the name of the manufacturer, and it may be that all of our manufacturers have different lengths, and I need to do it with a space. So I get to choose the delimiter that I want to use first. So column, etc., etc., I can actually choose customer and then enter anything that I want. So if I had a particular escape character sequence, for example, or something else, then I can put that in here. I'm going to do it on a space, and I can choose whether to split it just once at the first space, once at the right most delimiter in the column, or each occurrence of the delimiter. So, for example, if I had a sentence and I wanted to split them up into each word, then I could choose that and I'd get a column for each word. I've also got options to specify how many columns, the maximum number of columns that I want to split it into, and again, using escape characters or other special characters. I'll leave that for here, and I'm just going to split it once on the space. Hit okay, and that's it, it's done, so I've created one column with just the manufacturers name in it, and another column with a code. So this is manufacturer name, and this is the product code. Just double click it to rename, and it's easy. So splitting up columns is really, really simple using this split column transformation.

Video Details

Duration: 2 minutes and 19 seconds
Country: United States
Language: English
License: All rights reserved
Genre: None
Views: 65
Posted by: csintl on Aug 15, 2016

if this is a duplicate of one you're already working on, please ignore. ----- (Please provide translations for these languages: Chinese (Simplified) (chi_hans), Chinese (Traditional) (chi_hant), English (eng), French (France) (fre_fr), German (ger), Italian (ita), Japanese (jpn), Korean (kor), Portuguese (Brazil) (por_br), Russian (rus), Spanish (spa).)

Caption and Translate

    Sign In/Register for Dotsub to translate this video.