title: Issue while splitting a column of a data frame into different columns
body: <p>This the sample of the dataframe I'm playing with.</p>
  <pre><code>structure(list(Company.Name = c(&quot;Ample Softech System&quot;, &quot;Ziff Davis LLC&quot;, 
  &quot;IIM Kozhikkode&quot;, &quot;Perennial&quot;, &quot;Irupar Sociedad Cooperativa&quot;, 
  &quot;md&quot;, &quot;&quot;), Job.Title = c(&quot;Data Analyst&quot;, &quot;Data Analyst&quot;, &quot;Data Analyst&quot;, 
  &quot;Data Analyst&quot;, &quot;Data Analyst&quot;, &quot;Data Analyst&quot;, &quot;Data Analyst&quot;
  ), Salaries.Reported = c(1L, 1L, 1L, 1L, 1L, 1L, 1L), Location = c(&quot;Pune&quot;, 
  &quot;Pune&quot;, &quot;Pune&quot;, &quot;Pune&quot;, &quot;Pune&quot;, &quot;Pune&quot;, &quot;Pune&quot;), Salary = c(&quot;₹35,563/mo&quot;, 
  &quot;₹5,21,474/yr&quot;, &quot;₹7,64,702/yr&quot;, &quot;₹16,123/mo&quot;, &quot;₹6,04,401/yr&quot;, 
  &quot;AFN 1,56,179/yr&quot;, &quot;₹23,500/mo&quot;)), row.names = 2274:2280, class = &quot;data.frame&quot;)
  </code></pre>
  <p>The column <strong>Salary</strong> contains figures in a pattern of (Currency_symbol+Figure+periodicity)
  eg:₹35,563/mo</p>
  <p>I have been trying to separate the pattern into different columns. I used the following code.</p>
  <pre><code>smpl = separate(sample, col = Salary, into = c( &quot;Currency_symbol&quot;, &quot;Salary_copy&quot;), sep = 1, remove = TRUE, convert =  TRUE) #separates currency_symbol into separate column
  smpl
  smpl2 = separate(smpl, col = Salary_copy, into = c('Salary_copy', 'Periodicity'), sep = -3, remove = TRUE, convert = TRUE) # separates periodicity to separate column
  smpl2
  </code></pre>
  <p>The issue I'm facing is that one row contains 3 characters as Currency-symbol <strong>(AFN)</strong>, while others are single characters.</p>
  <p>So these particular lines of code mentioned above are not able to separate the pattern into respective columns for that particular row.</p>
  <p>If I change the index of sep argument of the code, all other rows will be affected. How can I solve this particular issue?</p>